Use EMODE

-- Tables

Go
ALTER TABLE [dbo].[ARTICLE_COLOR_LOOKUP] ADD PRIMARY KEY (ARTICLE_CODE, COLOR_CODE)

Go
ALTER TABLE [dbo].[ARTICLE_LOOKUP] ADD PRIMARY KEY (ARTICLE_CODE)

Go
ALTER TABLE [dbo].[ARTICLE_LOOKUP_CRITERIA] ADD PRIMARY KEY (ID)

Go
ALTER TABLE [dbo].[CALENDAR_YEAR_LOOKUP] ADD PRIMARY KEY (WEEK_KEY)

Go
ALTER TABLE [dbo].[OUTLET_LOOKUP] ADD PRIMARY KEY (SHOP_CODE)

Go
ALTER TABLE [PRODUCT_PROMOTION_FACTS] ADD CONSTRAINT PK_PRODUCT_PROMOTION_FACTS PRIMARY KEY ([ID] ASC) ON DATA_DEFAULT

Go
ALTER TABLE [dbo].[PROMOTION_LOOKUP] ADD PRIMARY KEY (PROMOTION_KEY)

Go
ALTER TABLE [SHOP_FACTS] ADD CONSTRAINT PK_SHOP_FACTS PRIMARY KEY ([ID] ASC) ON DATA_DEFAULT